package com.example.core.dao;

import com.example.core.entity.*;
import org.apache.ibatis.annotations.Param;

import java.util.List;

public interface DatabaseDao {

    //1.填报信息统计表(JXS_REP_TOTAL_INFO)
    void deleteJxsRepTotalInfo(@Param("yearId")String yearId, @Param("quarterId")String quarterId);
    void insertJxsRepTotalInfo(List<JxsRepTotalInfo> paramList);

    //2、关键指标概览总体表(JXS_REP_KPI_TTL)
    void deleteJxsRepKpiTtl(@Param("yearId")String yearId, @Param("quarterId")String quarterId);
    void insertJxsRepKpiTtl(List<JxsRepKpiTtl> paramList);

    //3.关键指标概览新车表(JXS_REP_KPI_NCS)
    void deleteJxsRepKpiNcs(@Param("yearId")String yearId, @Param("quarterId")String quarterId);
    void insertJxsRepKpiNcs(List<JxsRepKpiNcs> paramList);

    //4.关键指标概览售后表(JXS_REP_KPI_AS)
    void deleteJxsRepKpiAs(@Param("yearId")String yearId, @Param("quarterId")String quarterId);
    void insertJxsRepKpiAs(List<JxsRepKpiAs> paramList);

    //5、经销商盈利性分布表(JXS_REP_PROFIT_DISTRIBUTE)
    void deleteJxsRepProfitDistribute(@Param("yearId")String yearId, @Param("quarterId")String quarterId);
    void insertJxsRepProfitDistribute(List<JxsRepProfitDistribute> paramList);

    //6、经销商税前净利润率分段信息表(JXS_REP_RATE_PROP)
    void deleteJxsRepRateProp(@Param("yearId")String yearId, @Param("quarterId")String quarterId);
    void insertJxsRepRateProp(List<JxsRepRateProp> paramList);

    //7、盈利驱动分析信息表(JXS_REP_PROFIT_ANAL)
    void deleteJxsRepProfitAnal(@Param("yearId")String yearId, @Param("quarterId")String quarterId);
    void insertJxsRepProfitAnal(List<JxsRepProfitAnal> paramList);

    //8、新车业务单元毛利贡献表(JXS_REP_NCS_GROSS_PROFIT)
    void deleteJxsRepNcsGrossProfit(@Param("yearId")String yearId, @Param("quarterId")String quarterId);
    void insertJxsRepNcsGrossProfit(List<JxsRepNcsGrossProfit> paramList);

    //9、售后业务单元毛利贡献表(JXS_REP_AS_GROSS_PROFIT)
    void deleteJxsRepAsGrossProfit(@Param("yearId")String yearId, @Param("quarterId")String quarterId);
    void insertJxsRepAsGrossProfit(List<JxsRepAsGrossProfit> paramList);

    //10、平均单店费用及费用率表(JXS_REP_AVREV_COST_RATIO)
    void deleteJxsRepAvrevCostRatio(@Param("yearId")String yearId, @Param("quarterId")String quarterId);
    void insertJxsRepAvrevCostRatio(List<JxsRepAvrevCostRatio> paramList);

    //11、平均单车费用表(JXS_REP_AVRCAR_COST)
    void deleteJxsRepAvrcarCost(@Param("yearId")String yearId, @Param("quarterId")String quarterId);
    void insertJxsRepAvrcarCost(List<JxsRepAvrcarCost> paramList);

    //12、新车业务概览信息表（JXS_REP_NCS_TOTAL_INFO）
    void deleteJxsRepNcsTotalInfo(@Param("yearId")String yearId, @Param("quarterId")String quarterId);
    void insertJxsRepNcsTotalInfo(List<JxsRepNcsTotalInfo> paramList);

    //13、新车业务单元毛利贡献表(JXS_REP_NCS_GROSS_INFO)
    void deleteJxsRepNcsGrossInfo(@Param("yearId")String yearId, @Param("quarterId")String quarterId);
    void insertJxsRepNcsGrossInfo(List<JxsRepNcsGrossInfo> paramList);

    //14、新车毛利贡献预估表(JXS_REP_NCS_GROSS_PRO)
    void deleteJxsRepNcsGrossPro(@Param("yearId")String yearId, @Param("quarterId")String quarterId);
    void insertJxsRepNcsGrossPro(List<JxsRepNcsGrossPro> paramList);

    //15、新车衍生业务经营信息表(JXS_REP_NCS_DER_MANGE)
    void deleteJxsRepNcsDerMange(@Param("yearId")String yearId, @Param("quarterId")String quarterId);
    void insertJxsRepNcsDerMange(List<JxsRepNcsDerMange> paramList);

    //16、售后季度概览表(JXS_REP_AS_TOTAL_INFO)
    void deleteJxsRepAsTotalInfo(@Param("yearId")String yearId, @Param("quarterId")String quarterId);
    void insertJxsRepAsTotalInfo(List<JxsRepAsTotalInfo> paramList);

    //16-1、售后业务单元毛利贡献预估表(JXS_REP_AS_GROSS_PRO)
    void deleteJxsRepAsGrossPro(@Param("yearId")String yearId, @Param("quarterId")String quarterId);
    void insertJxsRepAsGrossPro(List<JxsRepAsGrossPro> paramList);

    //17、售后业务单元总体盈利总体Ⅰ表(JXS_REP_AS_OUTPUT_GROSS)
    void deleteJxsRepAsOutputGross(@Param("yearId")String yearId, @Param("quarterId")String quarterId);
    void insertJxsRepAsOutputGross(List<JxsRepAsOutputGross> paramList);

    //18、售后业务单元总体盈利总体Ⅱ表(JXS_REP_AS_OUTPUT_GROSS19)
    void deleteJxsRepAsOutputGross19(@Param("yearId")String yearId, @Param("quarterId")String quarterId);
    void insertJxsRepAsOutputGross19(List<JxsRepAsOutputGross19> paramList);

    //19、售后业务单元盈利情况Ⅰ表(JXS_REP_AS_OUTPUT_NUM)
    void deleteJxsRepAsOutputNum(@Param("yearId")String yearId, @Param("quarterId")String quarterId);
    void insertJxsRepAsOutputNum(List<JxsRepAsOutputNum> paramList);

    //20、售后业务单元盈利情况Ⅱ表(JXS_REP_AS_OUTPUT_RATE_TAX)
    void deleteJxsRepAsOutputRateTax(@Param("yearId")String yearId, @Param("quarterId")String quarterId);
    void insertJxsRepAsOutputRateTax(List<JxsRepAsOutputRateTax> paramList);

    //21、二手车业务概览信息表(JXS_REP_UC_TOTAL_INFO)
    void deleteJxsRepUcTotalInfo(@Param("yearId")String yearId, @Param("quarterId")String quarterId);
    void insertJxsRepUcTotalInfo(List<JxsRepUcTotalInfo> paramList);

    //22、二手车业务概览信息表(JXS_REP_UC_REVENUE_GROSS)
    void deleteJxsRepUcRevenueGross(@Param("yearId")String yearId, @Param("quarterId")String quarterId);
    void insertJxsRepUcRevenueGross(List<JxsRepUcRevenueGross> paramList);

    //
    void deleteJxsWriteStatis(@Param("yearId")String yearId, @Param("quarterId")String quarterId);
    void insertJxsWriteStatis(List<JxsWriteStatis> paramList);























}
